Nebula 1/Nebula One.iso/Misc/msql-1.0.6/src/tests/rtest.src/9.test

Text File | 1994-12-12 | 259b | 11 lines

# Force a duplicate user and do a distinct ordered join

insert into test2 (user, fullname) values ('fred','Fred Smith') \p\g

select distinct test2.user, test.age
        from test2,test
        where test2.user = test.user
        order by test2.user
\p\g